Row


Dataset Information

Number of Row with given data is 1644

Number of Column with given data is 32

Total Count of missing data is 3944

Row


Preview of data set

top 5 data is below

  EXMD_BZ_YYYY RN_INDI HME_YYYYMM Q_PHX_DX_STK Q_PHX_DX_HTDZ Q_PHX_DX_HTN Q_PHX_DX_DM Q_PHX_DX_DLD Q_PHX_DX_PTB Q_HBV_AG Q_SMK_YN
1         2009  562083     200909            0             0            1           0            0           NA        3        1
2         2009  334536     200911            0             0            0           0            0           NA        2        1
3         2009  911867     200903            0             0            0           0            0           NA        3        1
4         2009  183321     200908           NA            NA           NA          NA           NA           NA        3        1
5         2009  942671     200909           NA            NA           NA          NA           NA           NA        3        1
  Q_DRK_FRQ_V09N HGHT WGHT WSTC  BMI VA_LT VA_RT BP_SYS BP_DIA URN_PROT  HGB FBS TOT_CHOL  TG HDL LDL CRTN SGOT SGPT GGT GFR
1              0  144   61   90 29.4   0.7   0.8    120     80        1 12.6 117      264 128  60 179  0.9   25   20  25  59
2              0  162   51   63 19.4   0.8   1.0    120     80        1 13.8  96      169  92  70  80  0.9   18   15  28  74
3              0  163   65   82 24.5   0.7   0.6    130     80        1 15.0 118      216 132  55 134  0.8   26   30  30  79
4              0  152   51   70 22.1   0.8   0.9    101     62        1 13.1  90      199 100  65 114  0.9   18   14  11  61
5              0  159   50   73 19.8   0.7   0.8    132     78        1 13.0  92      162  58  40 111  0.9   24   23  15  49

last 5 data is below

     EXMD_BZ_YYYY RN_INDI HME_YYYYMM Q_PHX_DX_STK Q_PHX_DX_HTDZ Q_PHX_DX_HTN Q_PHX_DX_DM Q_PHX_DX_DLD Q_PHX_DX_PTB Q_HBV_AG Q_SMK_YN
1640         2015  266734     201504           NA            NA           NA          NA           NA           NA        1        2
1641         2015  343874     201511            0             0            0           1            0            0        2        2
1642         2015  798472     201507           NA            NA           NA          NA           NA           NA        3        2
1643         2015  720080     201505           NA            NA           NA          NA            1           NA        2        2
1644         2015  127519     201511            0             0            1           0            0            0        3        2
     Q_DRK_FRQ_V09N HGHT WGHT WSTC  BMI VA_LT VA_RT BP_SYS BP_DIA URN_PROT  HGB FBS TOT_CHOL  TG HDL LDL CRTN SGOT SGPT GGT GFR
1640              2  171   76   88 26.0   1.2   1.2    125     89        1 14.1  77      363 280  63 244  0.9   19   32  95  96
1641              0  179   80   88 25.0   1.0   0.7    126     83        1 14.9 119      106 247  29  50  0.9  101  157  62  79
1642              0  163   63   80 23.7   1.5   1.5    118     77        1 16.1 160      271 514  51 151  1.0   40   66 104  85
1643              1  165   70   92 25.7   0.6   0.8    120     80        1 13.6  81      289 810  52  NA  1.0   37   33  76  86
1644              4  168   84  103 29.8   0.9   0.8    140     85        1 15.2 134      210 298  56  94  1.1   55   49  66  66

Row


Missing Data

variable n_miss pct_miss
Q_PHX_DX_PTB 703 42.7615572
Q_PHX_DX_STK 573 34.8540146
Q_PHX_DX_HTDZ 566 34.4282238
Q_PHX_DX_DLD 566 34.4282238
Q_PHX_DX_DM 547 33.2725061
Q_PHX_DX_HTN 492 29.9270073
GFR 467 28.4063260
LDL 16 0.9732360
Q_DRK_FRQ_V09N 6 0.3649635
URN_PROT 4 0.2433090
Q_HBV_AG 2 0.1216545
Q_SMK_YN 2 0.1216545

Correlation

Row


Scatterplot

[1] “Number of Row Reduced to 1000”

Row


Column Attributes

1 Column name: EXMD_BZ_YYYY
Unique non-mission value count: 7
Missing value count: 0
cat n com_freq percent
2009 214 214 13.01703
2010 236 450 14.35523
2011 223 673 13.56448
2012 234 907 14.23358
2013 243 1150 14.78102
2014 254 1404 15.45012
2015 240 1644 14.59854
2 Column name: RN_INDI
Unique non-mission value count: 547
Missing value count: 0
Min Mean Median Max SD
2270 490782.2 487160 1010623 290056.7
3 Column name: HME_YYYYMM
Unique non-mission value count: 84
Missing value count: 0
Min Mean Median Max SD
200901 201216.2 201210 201512 199.1095
4 Column name: Q_PHX_DX_STK
Unique non-mission value count: 2
Missing value count: 1
cat n com_freq percent
0 1059 1059 64.416058
1 12 1071 0.729927
NA 573 1644 34.854015
5 Column name: Q_PHX_DX_HTDZ
Unique non-mission value count: 2
Missing value count: 1
cat n com_freq percent
0 1052 1052 63.990268
1 26 1078 1.581508
NA 566 1644 34.428224
6 Column name: Q_PHX_DX_HTN
Unique non-mission value count: 2
Missing value count: 1
cat n com_freq percent
0 864 864 52.55474
1 288 1152 17.51825
NA 492 1644 29.92701
7 Column name: Q_PHX_DX_DM
Unique non-mission value count: 2
Missing value count: 1
cat n com_freq percent
0 1021 1021 62.104623
1 76 1097 4.622871
NA 547 1644 33.272506
8 Column name: Q_PHX_DX_DLD
Unique non-mission value count: 2
Missing value count: 1
cat n com_freq percent
0 1035 1035 62.956204
1 43 1078 2.615572
NA 566 1644 34.428224
9 Column name: Q_PHX_DX_PTB
Unique non-mission value count: 2
Missing value count: 1
cat n com_freq percent
0 915 915 55.656934
1 26 941 1.581508
NA 703 1644 42.761557
10 Column name: Q_HBV_AG
Unique non-mission value count: 3
Missing value count: 1
cat n com_freq percent
1 77 77 4.6836983
2 1102 1179 67.0316302
3 463 1642 28.1630170
NA 2 1644 0.1216545
11 Column name: Q_SMK_YN
Unique non-mission value count: 3
Missing value count: 1
cat n com_freq percent
1 995 995 60.5231144
2 256 1251 15.5717762
3 391 1642 23.7834550
NA 2 1644 0.1216545
12 Column name: Q_DRK_FRQ_V09N
Unique non-mission value count: 8
Missing value count: 1
cat n com_freq percent
0 805 805 48.9659367
1 379 1184 23.0535280
2 249 1433 15.1459854
3 121 1554 7.3600973
4 28 1582 1.7031630
5 24 1606 1.4598540
6 15 1621 0.9124088
7 17 1638 1.0340633
NA 6 1644 0.3649635
13 Column name: HGHT
Unique non-mission value count: 51
Missing value count: 0
Min Mean Median Max SD
134 164.5487 165 188 9.185884
14 Column name: WGHT
Unique non-mission value count: 81
Missing value count: 0
Min Mean Median Max SD
31 65.09672 64 118 12.52964
15 Column name: WSTC
Unique non-mission value count: 57
Missing value count: 0
Min Mean Median Max SD
57 80.68917 81 114 9.547019
16 Column name: BMI
Unique non-mission value count: 168
Missing value count: 0
Min Mean Median Max SD
12.3 23.92257 23.7 37.2 3.378967
17 Column name: VA_LT
Unique non-mission value count: 16
Missing value count: 0
Min Mean Median Max SD
0.1 0.9840024 1 9.9 0.5558351
18 Column name: VA_RT
Unique non-mission value count: 16
Missing value count: 0
Min Mean Median Max SD
0.1 0.9791971 1 9.9 0.560936
19 Column name: BP_SYS
Unique non-mission value count: 87
Missing value count: 0
Min Mean Median Max SD
81 122.2555 120 180 14.62929
20 Column name: BP_DIA
Unique non-mission value count: 62
Missing value count: 0
Min Mean Median Max SD
49 76.59672 78 120 10.05631
21 Column name: URN_PROT
Unique non-mission value count: 5
Missing value count: 1
cat n com_freq percent
1 1565 1565 95.1946472
2 38 1603 2.3114355
3 23 1626 1.3990268
4 12 1638 0.7299270
5 2 1640 0.1216545
NA 4 1644 0.2433090
22 Column name: HGB
Unique non-mission value count: 97
Missing value count: 0
Min Mean Median Max SD
5.9 14.10572 14.1 18.3 1.691871
23 Column name: FBS
Unique non-mission value count: 106
Missing value count: 0
Min Mean Median Max SD
61 97.22993 94 290 20.13323
24 Column name: TOT_CHOL
Unique non-mission value count: 189
Missing value count: 0
Min Mean Median Max SD
68 194.9319 193 363 36.56853
25 Column name: TG
Unique non-mission value count: 332
Missing value count: 0
Min Mean Median Max SD
13 134.9033 106 1210 104.7511
26 Column name: HDL
Unique non-mission value count: 83
Missing value count: 0
Min Mean Median Max SD
23 55.90389 54 593 19.4672
27 Column name: LDL
Unique non-mission value count: 176
Missing value count: 1
Min Mean Median Max SD
19 118.688 112 8100 201.9903
28 Column name: CRTN
Unique non-mission value count: 30
Missing value count: 0
Min Mean Median Max SD
0.4 0.9891119 0.9 16.5 1.01597
29 Column name: SGOT
Unique non-mission value count: 80
Missing value count: 0
Min Mean Median Max SD
6 25.59793 23 459 16.17677
30 Column name: SGPT
Unique non-mission value count: 106
Missing value count: 0
Min Mean Median Max SD
3 25.98297 20 779 27.17625
31 Column name: GGT
Unique non-mission value count: 151
Missing value count: 0
Min Mean Median Max SD
6 36.34002 24.5 408 36.42819
32 Column name: GFR
Unique non-mission value count: 120
Missing value count: 1
Min Mean Median Max SD
3 89.74172 87 196 21.70754

Row


Report information

this report is generated with Statgarten @ 2022-09-14 01:18:07